---
title: SAIF.Business.View.Policy SQL catalog
summary: Index of all SQL statements and stored procedure calls used by this library, grouped by CRUD type.
status: draft
owner: SAIF Claims BOF team
last_reviewed: 2026-08-21
library: SAIF.Business.View.Policy
reference_type: embedded
---

# SAIF.Business.View.Policy SQL catalog

This page indexes all SQL statements and stored procedure calls in `SAIF.Business.View.Policy`,
grouped by CRUD type. This library is exclusively **read-only** — every `Criteria.CreateSQL` /
`InsertSQL` / `UpdateSQL` / `DeleteSQL` implementation returns empty or throws.

## Read operations

| SQL ID | Description | Type | Tables | Business object | Notes |
| --- | --- | --- | --- | --- | --- |
| [SQL-VP-001](SQL-001-getagency.md) | Retrieve agency/agent record for a policy | Stored Proc | not directly visible (Oracle package) | `clsAgency` | — |
| [SQL-VP-002](SQL-002-mco-getmco.md) | Retrieve MCO assignments for a policy (MCO collection) | Stored Proc | not directly visible (Oracle package) | `clsMCOCollection` | — |
| [SQL-VP-003](SQL-003-policymco-getmco.md) | Retrieve MCO assignments for a policy (duplicate call) | Stored Proc | not directly visible (Oracle package) | `clsPolicyMCOCollection` | — |
| [SQL-VP-004](SQL-004-getpolicyaffiliatelist.md) | Retrieve affiliated-policy list for a policy | Stored Proc | not directly visible (Oracle package) | `clsAffiliatedPolicyCollection` | — |
| [SQL-VP-005](SQL-005-getpolicyaddress.md) | Retrieve policy address by type/contact type | Stored Proc | not directly visible (Oracle package) | `clsPolicyAddress` | — |
| [SQL-VP-006](SQL-006-getpolicyaddressbylocseqnum.md) | Retrieve policy address by location sequence number | Stored Proc | not directly visible (Oracle package) | `clsPolicyAddress` | — |
| [SQL-VP-007](SQL-007-retrieveofficerofnoticesql.md) | Retrieve Officer of Notice contact for a policy | Inline | [BUSINESS_AFFILIATE](../database-tables.md#business_affiliate), [AFFILIATE](../database-tables.md#affiliate) | `clsPolicyAddress` | — |
| [SQL-VP-008](SQL-008-getpolicy.md) | Retrieve the main policy header record | Stored Proc | not directly visible (Oracle package) | `clsPolicyData` | — |
| [SQL-VP-009](SQL-009-getgaps.md) | Retrieve coverage gaps for a policy | Stored Proc | not directly visible (Oracle package) | `clsPolicyData` | — |
| [SQL-VP-010](SQL-010-get_policy_waiver_count.md) | Retrieve waiver count for a policy | Stored Proc | not directly visible (Oracle package) | `clsPolicyData` | — |
| [SQL-VP-011](SQL-011-getviewdetail.md) | Retrieve additional policy view detail | Stored Proc | not directly visible (Oracle package) | `clsPolicyData` | — |
| [SQL-VP-012](SQL-012-getlastauditdate.md) | Retrieve the most recent audit date for a policy | Inline | [PA_AUDIT](../database-tables.md#pa_audit) | `clsPolicyData` | — |
| [SQL-VP-013](SQL-013-getfuturecanceldate.md) | Retrieve a future cancellation date for a policy | Inline | [CANCELLATION](../database-tables.md#cancellation) | `clsPolicyData` | — |
| [SQL-VP-014](SQL-014-getsecondarypolicystatus.md) | Retrieve a policy's secondary cancel status | Inline (scalar function) | [DUAL](../database-tables.md#dual) | `clsPolicyData` | — |
| [SQL-VP-015](SQL-015-getcoverageboundflag.md) | Retrieve whether coverage is bound for a policy period | Inline (scalar function) | [DUAL](../database-tables.md#dual) | `clsPolicyData` | — |
| [SQL-VP-016](SQL-016-isinformationpageprinted.md) | Retrieve whether the information page has been printed | Stored Proc | not directly visible (Oracle procedure) | `clsPolicyData` | — |
| [SQL-VP-017](SQL-017-getparentpolicydata.md) | Retrieve a policy's parent policy number | Stored Proc | not directly visible (Oracle package) | `clsPolicyData` | Obsolete |
| [SQL-VP-018](SQL-018-getaffiliatetype.md) | Retrieve a policy's affiliate type | Stored Proc | not directly visible (Oracle package) | `clsPolicyData` | Obsolete |
| [SQL-VP-019](SQL-019-getwrapuplegalname.md) | Retrieve the wrapup legal name for a policy | Stored Proc | not directly visible (Oracle package) | `clsPolicyData` | — |
| [SQL-VP-021](SQL-021-retrieveemployerliablimits.md) | Retrieve employer-liability coverage limits for a period | Stored Proc | not directly visible (Oracle package) | `clsPolicyPeriod` | — |
| [SQL-VP-022](SQL-022-getpolicyperiods.md) | Retrieve policy periods for a policy | Stored Proc | not directly visible (Oracle package) | `clsPolicyPeriodCollection` | — |
| [SQL-VP-023](SQL-023-trading_as.md) | Retrieve trading-as names for a policy | Inline | [TRADING_AS](../database-tables.md#trading_as) | `clsTradingAsCollection` | — |
| [SQL-VP-024](SQL-024-team_assign_query.md) | Retrieve team-assignment roster for a policy | Stored Proc | not directly visible (Oracle package) | `clsTeamAssignmentCollection` | — |
| [SQL-VP-025](SQL-025-cp_external_client_lookup.md) | Look up external client email address (SQL Server) | Stored Proc | not directly visible (SQL Server procedure) | `clsTeamAssignment` | — |
| [SQL-VP-026](SQL-026-sp73341_external_client_lookup.md) | Look up external client email address by system user (Oracle) | Stored Proc | not directly visible (Oracle procedure) | `clsTeamAssignment` | — |
| [SQL-VP-027](SQL-027-association_type_code.md) | Retrieve all policy-association type codes | Inline | [ASSOCIATION_TYPE_CODE](../database-tables.md#association_type_code) | `clsAssociationTypeCode` / `clsAssociationTypeCodeCollection` | — |
| [SQL-VP-028](SQL-028-perioddatesql.md) | Retrieve period dates for a set of policy numbers | Inline | [POLICY_PERIOD_ALL](../database-tables.md#policy_period_all), [ENDORSEMENT](../database-tables.md#endorsement), [POLICY_PERIOD_NON_WCIS](../database-tables.md#policy_period_non_wcis) | `clsAssociationTypeCode` | — |
| [SQL-VP-029](SQL-029-getnontypedassociations.md) | Retrieve non-typed associations via a dynamically named procedure | Stored Proc (dynamic name) | not directly visible (Oracle procedure) | `clsAssociationTypeCode` | — |
| [SQL-VP-030](SQL-030-retrieve_pms_sql.md) | Retrieve PMS-era payroll classification detail | Inline | [PPNW_CLASS_COVERAGE_DETAIL](../database-tables.md#ppnw_class_coverage_detail), [MANUAL_CLASS_DESCRIPTION](../database-tables.md#manual_class_description), [POLICY_PERIOD_NON_WCIS](../database-tables.md#policy_period_non_wcis) | `clsPayrollClassInfoCollection` | — |
| [SQL-VP-031](SQL-031-retrieve_wcis_sql.md) | Retrieve WCIS-era payroll classification detail | Inline | [PREM_HIST_CLASS_COVERAGE](../database-tables.md#prem_hist_class_coverage), [MANUAL_CLASS_DESCRIPTION](../database-tables.md#manual_class_description), [PREM_HIST_ADJ_RATE_CLASS](../database-tables.md#prem_hist_adj_rate_class), [POLICY_PERIOD](../database-tables.md#policy_period), [LOCATION](../database-tables.md#location), [FEDERAL_MINIMUM_WAGE](../database-tables.md#federal_minimum_wage) | `clsPayrollClassInfoCollection` | — |
| [SQL-VP-032](SQL-032-non_empr_acct.md) | Retrieve a non-employer account by account number | Inline | [NON_EMPR_ACCT](../database-tables.md#non_empr_acct) | `clsNonEmployerAccount` | — |
| [SQL-VP-033](SQL-033-isingroup.md) | Check whether a policy belongs to a group/chapter (SQL Server) | Stored Proc | not directly visible (SQL Server procedure) | `clsPolicySecurity` | — |
| [SQL-VP-034](SQL-034-getpolicylistforgroup.md) | Retrieve the group user's book of business (SQL Server) | Stored Proc | not directly visible (SQL Server procedure) | `clsPolicySecurity` | — |
| [SQL-VP-035](SQL-035-getpolicylistforsafetyconsultant.md) | Retrieve the loss-control consultant's book of business (SQL Server) | Stored Proc | not directly visible (SQL Server procedure) | `clsPolicySecurity` | — |
| [SQL-VP-036](SQL-036-getpolicylistforagent.md) | Retrieve an agent's online policy list (SQL Server) | Stored Proc | not directly visible (SQL Server procedure) | `clsPolicySecurity` | — |
| [SQL-VP-037](SQL-037-canauditoraccesspolicy.md) | Check whether a vendor auditor may access a policy | Inline | [PA_AUDIT](../database-tables.md#pa_audit), [PA_AUDITOR](../database-tables.md#pa_auditor), [PA_POLICY_PERIOD](../database-tables.md#pa_policy_period) | `clsPolicySecurity` | — |
| [SQL-VP-038](SQL-038-getauditorpolicylistsql.md) | Retrieve the fee auditor's accessible policy list | Inline | [PA_AUDIT](../database-tables.md#pa_audit), [PA_AUDITOR](../database-tables.md#pa_auditor), [POLICY](../database-tables.md#policy) | `clsPolicySecurity` | — |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [Security and authorization](../security-authorization.md)
- [API reference](../api/index.md)

> **Note:** Statements marked with `*` were inferred from code structure, naming
> conventions, or contextual evidence where direct confirmation was not available
> in source artifacts. Statements marked with `**` could not be confirmed; treat
> as unknown until verified.

## Sources
- `SAIF.Business.View.Policy\clsAgency.vb`
- `SAIF.Business.View.Policy\clsMCOCollection.vb`
- `SAIF.Business.View.Policy\clsPolicyMCOCollection.vb`
- `SAIF.Business.View.Policy\clsAffiliatedPolicyCollection.vb`
- `SAIF.Business.View.Policy\clsPolicyAddress.vb`
- `SAIF.Business.View.Policy\clsPolicyData.vb`
- `SAIF.Business.View.Policy\clsPolicyPeriod.vb`
- `SAIF.Business.View.Policy\clsPolicyPeriodCollection.vb`
- `SAIF.Business.View.Policy\clsTradingAsCollection.vb`
- `SAIF.Business.View.Policy\clsTeamAssignmentCollection.vb`
- `SAIF.Business.View.Policy\clsTeamAssignment.vb`
- `SAIF.Business.View.Policy\Associations\clsAssociationTypeCode.vb`
- `SAIF.Business.View.Policy\clsPayrollClassInfo.vb`
- `SAIF.Business.View.Policy\clsPayrollClassInfoCollection.vb`
- `SAIF.Business.View.Policy\clsNonEmployerAccount.vb`
- `SAIF.Business.View.Policy\clsPolicySecurity.vb`